Projects in Supply Chain Management

Power BI reports for a global Pharmaceutical company
Helped the client monitor the timeliness and completeness of product deliveries at a global scale, working with their Customer Analytics CoE, to implement OTIF related BI reports.

  • Redesigned the On-Time & Fill-Rate report calculations to accommodate different delivery dates, enhancing accuracy and flexibility in performance tracking.
  • Defined development specifications for Power BI and provided team guidance on DAX best practices, ensuring high-quality and efficient reporting as per client requirements.
  • Led the refactoring of Power BI and Snowflake models to address challenges posed by increased data volume, resulting in a 2.25x improvement in performance and a 2.15x reduction in capacity costs.

Power BI reports for a global Shipping Company
Matt helped the company manage the ship spares supply chain of various shipping companies globally, by designing & developing a set of Power BI reports with advanced UI features and row-level security to provide personalized information on shipments, costs, and ESG metrics. These tools enabled the client to convert raw data into insights, KPIs & market trends and had a profound impact on their business; as they allowed them to operate with emphasis on strategic adjustments and aim to higher efficiency, sustainability and cost savings.

3PL report sanitized 3PL report sanitized 3PL report sanitized

** The screenshots have been 'sanitized'(parts of the reports with sensitive information have been removed) and aproval for publication has been granted.

Power BI reporting pack for a Greek manufacturing company
Implemented BI reports to help a Greek manufacturer manage their global shipments & inventories, while also leveraging 3rd party tools to enable input within Power BI, facilitating scenarios on lead times and market demand.

Logistics Report Demo


Guidance on how to use the report Οδηγίες χρήσης της αναφοράς στα ελληνικά